PREVIEW / etf_30min / 2008-07-11

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-11.parquet
  size:    178 KB
  rows:    6,100

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-07-11 04:00:00	SPY	ETF	124.99	125.0	124.99	125.0	2500.0
2008-07-11 04:30:00	SPY	ETF	125.32	125.32	125.16	125.16	200.0
2008-07-11 05:00:00	SPY	ETF	125.07	125.07	125.05	125.05	25000.0
2008-07-11 05:30:00	SPY	ETF	124.99	125.07	124.85	124.85	17200.0
2008-07-11 06:00:00	SPY	ETF	124.86	124.86	124.38	124.58	83300.0
2008-07-11 06:30:00	SPY	ETF	124.72	125.04	124.3	124.66	467300.0
2008-07-11 07:00:00	SPY	ETF	124.63	124.7	123.92	124.25	1567220.0
2008-07-11 07:30:00	SPY	ETF	124.27	124.4	123.74	124.1	2244106.0
2008-07-11 08:00:00	SPY	ETF	124.1	126.0	123.63	123.83	4711362.0
2008-07-11 08:30:00	SPY	ETF	123.78	124.03	123.66	123.83	2846014.0
2008-07-11 09:00:00	SPY	ETF	123.82	124.1	123.6	123.93	5508242.0
2008-07-11 09:30:00	SPY	ETF	123.97	124.45	123.29	124.32	54834575.0
2008-07-11 10:00:00	SPY	ETF	124.32	125.0	123.19	123.51	48002955.0
2008-07-11 10:30:00	SPY	ETF	123.52	125.3154	123.14	123.66	34308627.0
2008-07-11 11:00:00	SPY	ETF	123.66	123.87	123.02	123.05	21869812.0
2008-07-11 11:30:00	SPY	ETF	123.04	123.52	122.64	123.51	30582798.0
2008-07-11 12:00:00	SPY	ETF	123.51	123.53	122.96	123.18	15388054.0
2008-07-11 12:30:00	SPY	ETF	123.18	123.19	122.53	122.79	15606439.0
2008-07-11 13:00:00	SPY	ETF	122.79	123.2	122.49	123.05	25365725.0
2008-07-11 13:30:00	SPY	ETF	123.05	123.76	122.96	123.48	23590658.0
2008-07-11 14:00:00	SPY	ETF	123.47	124.08	123.08	123.191	33052687.0
2008-07-11 14:30:00	SPY	ETF	123.19	125.3	122.96	124.9	41491191.0
2008-07-11 15:00:00	SPY	ETF	124.9	125.9	123.86	124.11	59843778.0
2008-07-11 15:30:00	SPY	ETF	124.11	124.34	123.21	124.02	42805540.0
2008-07-11 16:00:00	SPY	ETF	124.0299	124.25	123.27	123.44	5487656.0
2008-07-11 16:30:00	SPY	ETF	123.44	123.91	123.33	123.91	4036173.0
2008-07-11 17:00:00	SPY	ETF	123.85	124.0	123.85	123.95	87162.0
2008-07-11 17:30:00	SPY	ETF	124.0	124.2	123.95	124.1	91737.0
2008-07-11 18:00:00	SPY	ETF	124.12	124.2	124.03	124.13	75099.0
2008-07-11 18:30:00	SPY	ETF	124.17	124.26	123.96	124.18	50361.0
2008-07-11 19:00:00	SPY	ETF	124.02	124.2	123.92	123.92	8837.0
2008-07-11 19:30:00	SPY	ETF	123.92	123.92	123.8	123.87	13116.0
2008-07-11 04:00:00	QQQ	ETF	45.14	45.14	45.14	45.14	400.0
2008-07-11 05:30:00	QQQ	ETF	45.18	45.18	45.12	45.12	700.0
2008-07-11 06:00:00	QQQ	ETF	45.08	45.08	44.94	44.97	3600.0
2008-07-11 06:30:00	QQQ	ETF	45.04	45.11	44.96	44.96	69200.0
2008-07-11 07:00:00	QQQ	ETF	45.02	45.04	44.69	44.87	200106.0
2008-07-11 07:30:00	QQQ	ETF	44.87	44.92	44.73	44.84	893815.0
2008-07-11 08:00:00	QQQ	ETF	44.83	44.92	44.65	44.69	2174103.0
2008-07-11 08:30:00	QQQ	ETF	44.65	44.78	44.64	44.76	1283649.0
2008-07-11 09:00:00	QQQ	ETF	44.75	44.95	44.67	44.78	3347003.0
2008-07-11 09:30:00	QQQ	ETF	44.81	44.95	44.41	44.84	31673955.0
2008-07-11 10:00:00	QQQ	ETF	44.83	44.92	44.39	44.53	16110179.0
2008-07-11 10:30:00	QQQ	ETF	44.538	44.71	44.41	44.65	15955742.0
2008-07-11 11:00:00	QQQ	ETF	44.64	44.7	44.32	44.36	20132948.0
2008-07-11 11:30:00	QQQ	ETF	44.35	44.58	44.19	44.55	12426394.0
2008-07-11 12:00:00	QQQ	ETF	44.55	44.58	44.32	44.37	8360996.0
2008-07-11 12:30:00	QQQ	ETF	44.36	44.37	43.85	43.98	16879682.0
2008-07-11 13:00:00	QQQ	ETF	43.97	44.22	43.9	44.19	13549746.0
2008-07-11 13:30:00	QQQ	ETF	44.18	44.45	44.141	44.35	11837196.0

> showing 50 of 6,100 rows — these rows as CSV

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