PREVIEW / etf_30min / 2008-04-10

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-10.parquet
  size:    152 KB
  rows:    5,553

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-10 05:00:00	SPY	ETF	135.16	135.16	135.1	135.1	500.0
2008-04-10 05:30:00	SPY	ETF	135.25	135.25	135.25	135.25	300.0
2008-04-10 06:00:00	SPY	ETF	135.23	135.23	135.04	135.18	22600.0
2008-04-10 06:30:00	SPY	ETF	135.26	135.37	135.19	135.31	58300.0
2008-04-10 07:00:00	SPY	ETF	135.3	135.35	135.01	135.2	682900.0
2008-04-10 07:30:00	SPY	ETF	135.25	135.38	135.12	135.13	223900.0
2008-04-10 08:00:00	SPY	ETF	135.16	135.43	134.98	135.29	1666500.0
2008-04-10 08:30:00	SPY	ETF	135.35	135.81	135.05	135.41	2660300.0
2008-04-10 09:00:00	SPY	ETF	135.4	135.54	135.35	135.39	635800.0
2008-04-10 09:30:00	SPY	ETF	135.39	135.67	134.97	135.09	17302145.0
2008-04-10 10:00:00	SPY	ETF	135.09	135.69	134.9	135.69	17381991.0
2008-04-10 10:30:00	SPY	ETF	135.68	136.22	135.48	136.19	17699895.0
2008-04-10 11:00:00	SPY	ETF	136.19	136.44	135.92	136.21	15218769.0
2008-04-10 11:30:00	SPY	ETF	136.22	136.61	136.16	136.54	15734205.0
2008-04-10 12:00:00	SPY	ETF	136.55	136.67	136.25	136.3	7766578.0
2008-04-10 12:30:00	SPY	ETF	136.3	136.59	136.09	136.14	10678295.0
2008-04-10 13:00:00	SPY	ETF	136.14	136.38	136.12	136.32	6147440.0
2008-04-10 13:30:00	SPY	ETF	136.32	136.64	136.25	136.27	7655107.0
2008-04-10 14:00:00	SPY	ETF	136.27	136.36	135.98	136.04	11777708.0
2008-04-10 14:30:00	SPY	ETF	136.03	136.5	135.84	136.41	9539799.0
2008-04-10 15:00:00	SPY	ETF	136.41	136.53	136.07	136.19	11629128.0
2008-04-10 15:30:00	SPY	ETF	136.18	136.18	135.55	135.94	20682978.0
2008-04-10 16:00:00	SPY	ETF	135.87	136.42	135.3709	136.02	6926700.0
2008-04-10 16:30:00	SPY	ETF	136.02	136.22	135.37	136.16	4483838.0
2008-04-10 17:00:00	SPY	ETF	136.16	136.29	136.16	136.29	234200.0
2008-04-10 17:30:00	SPY	ETF	136.29	137.371	135.371	136.25	3078200.0
2008-04-10 18:00:00	SPY	ETF	136.24	136.24	136.14	136.16	67200.0
2008-04-10 18:30:00	SPY	ETF	136.16	136.22	136.13	136.15	176900.0
2008-04-10 19:00:00	SPY	ETF	136.14	136.33	136.13	136.26	106300.0
2008-04-10 19:30:00	SPY	ETF	136.24	136.36	136.22	136.36	23500.0
2008-04-10 05:00:00	QQQ	ETF	44.84	44.84	44.82	44.82	1557.0
2008-04-10 05:30:00	QQQ	ETF	44.82	44.83	44.8	44.83	900.0
2008-04-10 06:00:00	QQQ	ETF	44.8	44.8	44.77	44.77	820.0
2008-04-10 06:30:00	QQQ	ETF	44.88	44.91	44.88	44.91	3600.0
2008-04-10 07:00:00	QQQ	ETF	44.88	44.93	44.77	44.88	260355.0
2008-04-10 07:30:00	QQQ	ETF	44.88	44.97	44.87	44.9	97457.0
2008-04-10 08:00:00	QQQ	ETF	44.91	44.91	44.69	44.91	2488436.0
2008-04-10 08:30:00	QQQ	ETF	44.85	44.95	44.78	44.92	771961.0
2008-04-10 09:00:00	QQQ	ETF	44.92	44.95	44.89	44.94	557352.0
2008-04-10 09:30:00	QQQ	ETF	44.93	45.22	44.93	45.02	16404944.0
2008-04-10 10:00:00	QQQ	ETF	45.01	45.45	44.94	45.44	16332208.0
2008-04-10 10:30:00	QQQ	ETF	45.44	45.67	45.37	45.64	10403488.0
2008-04-10 11:00:00	QQQ	ETF	45.64	45.71	45.54	45.63	7300731.0
2008-04-10 11:30:00	QQQ	ETF	45.63	45.77	45.57	45.701	7887843.0
2008-04-10 12:00:00	QQQ	ETF	45.71	45.74	45.61	45.6401	3088580.0
2008-04-10 12:30:00	QQQ	ETF	45.64	45.73	45.58	45.62	3334674.0
2008-04-10 13:00:00	QQQ	ETF	45.63	45.77	45.6	45.7301	4846330.0
2008-04-10 13:30:00	QQQ	ETF	45.73	45.84	45.64	45.65	5247796.0
2008-04-10 14:00:00	QQQ	ETF	45.65	45.74	45.57	45.58	5990789.0
2008-04-10 14:30:00	QQQ	ETF	45.59	45.76	45.5	45.73	6764660.0

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

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