PREVIEW / etf_30min / 2008-04-17

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-17.parquet
  size:    164 KB
  rows:    5,786

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2008-04-17 04:30:00	SPY	ETF	136.39	136.39	136.39	136.39	200.0
2008-04-17 05:30:00	SPY	ETF	136.34	136.36	136.34	136.36	1000.0
2008-04-17 06:00:00	SPY	ETF	136.33	136.7	136.26	136.61	5276.0
2008-04-17 06:30:00	SPY	ETF	136.53	136.76	136.51	136.51	174800.0
2008-04-17 07:00:00	SPY	ETF	136.51	136.58	136.18	136.28	548143.0
2008-04-17 07:30:00	SPY	ETF	136.35	136.39	136.24	136.26	212304.0
2008-04-17 08:00:00	SPY	ETF	136.26	136.36	135.88	136.07	827879.0
2008-04-17 08:30:00	SPY	ETF	136.03	136.21	135.86	135.97	2137113.0
2008-04-17 09:00:00	SPY	ETF	135.98	136.4174	135.86	136.02	1242851.0
2008-04-17 09:30:00	SPY	ETF	136.02	136.5	135.88	136.138	16580842.0
2008-04-17 10:00:00	SPY	ETF	136.12	136.59	135.75	136.41	21851495.0
2008-04-17 10:30:00	SPY	ETF	136.41	136.65	136.17	136.27	13417233.0
2008-04-17 11:00:00	SPY	ETF	136.27	136.45	135.8	135.8601	10710867.0
2008-04-17 11:30:00	SPY	ETF	135.87	135.97	135.66	135.79	10279430.0
2008-04-17 12:00:00	SPY	ETF	135.8	136.04	135.73	135.79	6887688.0
2008-04-17 12:30:00	SPY	ETF	135.79	136.14	135.68	136.1	6640962.0
2008-04-17 13:00:00	SPY	ETF	136.11	136.4	136.05	136.38	9272906.0
2008-04-17 13:30:00	SPY	ETF	136.38	136.52	136.17	136.2	10454981.0
2008-04-17 14:00:00	SPY	ETF	136.2	136.5	136.0	136.15	6594220.0
2008-04-17 14:30:00	SPY	ETF	136.15	136.46	136.14	136.22	10927644.0
2008-04-17 15:00:00	SPY	ETF	136.22	136.67	136.11	136.46	17137803.0
2008-04-17 15:30:00	SPY	ETF	136.46	136.82	136.42	136.48	21963975.0
2008-04-17 16:00:00	SPY	ETF	136.44	137.24	136.29	137.21	5975830.0
2008-04-17 16:30:00	SPY	ETF	137.21	137.41	136.97	137.22	1008840.0
2008-04-17 17:00:00	SPY	ETF	137.24	137.35	137.19	137.31	851178.0
2008-04-17 17:30:00	SPY	ETF	137.29	137.35	137.28	137.29	27523.0
2008-04-17 18:00:00	SPY	ETF	137.34	137.35	137.22	137.28	43485.0
2008-04-17 18:30:00	SPY	ETF	137.28	137.31	137.25	137.28	1650.0
2008-04-17 19:00:00	SPY	ETF	137.29	137.29	137.22	137.24	4598.0
2008-04-17 19:30:00	SPY	ETF	137.24	137.24	137.19	137.2	13899.0
2008-04-17 04:00:00	QQQ	ETF	45.52	45.52	45.52	45.52	200.0
2008-04-17 05:30:00	QQQ	ETF	45.6	45.6	45.6	45.6	500.0
2008-04-17 06:00:00	QQQ	ETF	45.56	45.59	45.46	45.59	64400.0
2008-04-17 06:30:00	QQQ	ETF	45.65	45.65	45.57	45.58	80659.0
2008-04-17 07:00:00	QQQ	ETF	45.58	45.62	45.47	45.55	525579.0
2008-04-17 07:30:00	QQQ	ETF	45.56	45.57	45.51	45.53	125419.0
2008-04-17 08:00:00	QQQ	ETF	45.51	45.53	45.39	45.44	963641.0
2008-04-17 08:30:00	QQQ	ETF	45.43	45.48	45.38	45.41	1458020.0
2008-04-17 09:00:00	QQQ	ETF	45.41	45.46	45.36	45.42	1469347.0
2008-04-17 09:30:00	QQQ	ETF	45.42	45.47	45.2	45.3	14868476.0
2008-04-17 10:00:00	QQQ	ETF	45.3	45.39	45.14	45.3	9940789.0
2008-04-17 10:30:00	QQQ	ETF	45.3	45.37	45.2	45.2475	5713956.0
2008-04-17 11:00:00	QQQ	ETF	45.24	45.27	45.08	45.108	4421094.0
2008-04-17 11:30:00	QQQ	ETF	45.11	45.13	45.0	45.07	7511737.0
2008-04-17 12:00:00	QQQ	ETF	45.08	45.16	45.03	45.04	5204789.0
2008-04-17 12:30:00	QQQ	ETF	45.05	45.25	44.98	45.21	5896862.0
2008-04-17 13:00:00	QQQ	ETF	45.218	45.26	45.14	45.2305	4607464.0
2008-04-17 13:30:00	QQQ	ETF	45.24	45.25	45.12	45.1401	4336217.0
2008-04-17 14:00:00	QQQ	ETF	45.14	45.16	45.06	45.13	4067778.0
2008-04-17 14:30:00	QQQ	ETF	45.13	45.24	45.08	45.12	4909546.0

> showing 50 of 5,786 rows — these rows as CSV

> unlock the full archive -- $79 one-time