PREVIEW / etf_30min / 2010-03-11

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-11.parquet
  size:    243 KB
  rows:    8,145

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
2010-03-11 04:00:00	SPY	ETF	114.7	114.78	114.7	114.78	1750.0
2010-03-11 05:00:00	SPY	ETF	114.86	114.86	114.86	114.86	500.0
2010-03-11 05:30:00	SPY	ETF	114.76	114.76	114.72	114.72	2700.0
2010-03-11 06:00:00	SPY	ETF	114.72	114.92	114.72	114.87	4000.0
2010-03-11 06:30:00	SPY	ETF	114.86	114.91	114.69	114.74	6200.0
2010-03-11 07:00:00	SPY	ETF	114.73	114.83	114.69	114.73	75296.0
2010-03-11 07:30:00	SPY	ETF	114.76	114.86	114.76	114.82	158703.0
2010-03-11 08:00:00	SPY	ETF	114.82	115.0	114.45	114.89	744691.0
2010-03-11 08:30:00	SPY	ETF	114.88	114.88	114.53	114.65	1596154.0
2010-03-11 09:00:00	SPY	ETF	114.66	114.72	114.5	114.7	1068088.0
2010-03-11 09:30:00	SPY	ETF	114.7	114.83	114.35	114.51	17519695.0
2010-03-11 10:00:00	SPY	ETF	114.515	114.86	114.5	114.76	12197663.0
2010-03-11 10:30:00	SPY	ETF	114.77	115.09	114.76	114.9884	10314755.0
2010-03-11 11:00:00	SPY	ETF	114.99	115.02	114.85	114.8801	8438574.0
2010-03-11 11:30:00	SPY	ETF	114.89	114.93	114.76	114.92	5588453.0
2010-03-11 12:00:00	SPY	ETF	114.92	114.93	114.63	114.64	17785311.0
2010-03-11 12:30:00	SPY	ETF	114.64	114.87	114.62	114.87	7853323.0
2010-03-11 13:00:00	SPY	ETF	114.86	114.96	114.8	114.9	4202179.0
2010-03-11 13:30:00	SPY	ETF	114.9	115.05	114.86	114.86	5339649.0
2010-03-11 14:00:00	SPY	ETF	114.87	114.91	114.75	114.85	8106932.0
2010-03-11 14:30:00	SPY	ETF	114.84	114.98	114.8	114.9	6702768.0
2010-03-11 15:00:00	SPY	ETF	114.91	115.36	114.9	115.25	12683951.0
2010-03-11 15:30:00	SPY	ETF	115.25	115.48	115.15	115.46	19949999.0
2010-03-11 16:00:00	SPY	ETF	115.45	115.56	114.52	115.54	7389544.0
2010-03-11 16:30:00	SPY	ETF	115.53	115.58	115.45	115.52	5306298.0
2010-03-11 17:00:00	SPY	ETF	115.52	115.56	115.029	115.5	2151932.0
2010-03-11 17:30:00	SPY	ETF	115.52	115.53	115.5	115.53	5450.0
2010-03-11 18:00:00	SPY	ETF	115.51	115.53	115.45	115.53	183502.0
2010-03-11 18:30:00	SPY	ETF	115.53	115.53	115.48	115.52	116150.0
2010-03-11 19:00:00	SPY	ETF	115.5	115.53	115.5	115.5	14675.0
2010-03-11 19:30:00	SPY	ETF	115.5	115.57	115.45	115.57	180068.0
2010-03-11 04:30:00	QQQ	ETF	47.18	47.18	47.18	47.18	100.0
2010-03-11 06:30:00	QQQ	ETF	47.2	47.2	47.14	47.14	3487.0
2010-03-11 07:00:00	QQQ	ETF	47.14	47.17	47.12	47.14	133322.0
2010-03-11 07:30:00	QQQ	ETF	47.14	47.16	47.12	47.13	270060.0
2010-03-11 08:00:00	QQQ	ETF	47.16	47.18	47.14	47.18	61711.0
2010-03-11 08:30:00	QQQ	ETF	47.17	47.18	47.02	47.05	1217516.0
2010-03-11 09:00:00	QQQ	ETF	47.05	47.07	46.99	47.06	2532126.0
2010-03-11 09:30:00	QQQ	ETF	47.07	47.11	46.98	47.0507	8110271.0
2010-03-11 10:00:00	QQQ	ETF	47.06	47.18	47.05	47.1429	6338833.0
2010-03-11 10:30:00	QQQ	ETF	47.14	47.26	47.1	47.215	5669177.0
2010-03-11 11:00:00	QQQ	ETF	47.22	47.24	47.16	47.18	2500618.0
2010-03-11 11:30:00	QQQ	ETF	47.18	47.2	47.11	47.18	2105084.0
2010-03-11 12:00:00	QQQ	ETF	47.18	47.18	47.03	47.03	5230387.0
2010-03-11 12:30:00	QQQ	ETF	47.04	47.16	47.03	47.15	2206998.0
2010-03-11 13:00:00	QQQ	ETF	47.16	47.18	47.121	47.14	1629447.0
2010-03-11 13:30:00	QQQ	ETF	47.14	47.19	47.1	47.11	1601684.0
2010-03-11 14:00:00	QQQ	ETF	47.12	47.15	47.06	47.1038	3934017.0
2010-03-11 14:30:00	QQQ	ETF	47.1	47.17	47.07	47.1501	3057031.0
2010-03-11 15:00:00	QQQ	ETF	47.15	47.29	47.15	47.25	4780513.0

> showing 50 of 8,145 rows — these rows as CSV

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