PREVIEW / etf_30min / 2009-09-08

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-08.parquet
  size:    228 KB
  rows:    7,626

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
2009-09-08 04:00:00	SPY	ETF	103.05	103.16	103.0	103.16	3492.0
2009-09-08 04:30:00	SPY	ETF	103.0	103.05	102.89	102.89	1730.0
2009-09-08 05:00:00	SPY	ETF	102.9	102.99	102.9	102.92	40300.0
2009-09-08 05:30:00	SPY	ETF	103.04	103.04	103.0	103.0	1100.0
2009-09-08 06:00:00	SPY	ETF	102.88	102.95	102.86	102.86	6700.0
2009-09-08 06:30:00	SPY	ETF	102.86	102.9	102.8	102.8	13400.0
2009-09-08 07:00:00	SPY	ETF	102.86	103.03	102.85	103.03	133224.0
2009-09-08 07:30:00	SPY	ETF	103.03	103.05	102.96	103.01	371746.0
2009-09-08 08:00:00	SPY	ETF	103.0	103.13	102.2	102.89	958541.0
2009-09-08 08:30:00	SPY	ETF	102.89	102.93	102.82	102.92	549340.0
2009-09-08 09:00:00	SPY	ETF	102.92	103.03	102.88	103.0	1858852.0
2009-09-08 09:30:00	SPY	ETF	103.0	103.05	102.53	102.63	24895649.0
2009-09-08 10:00:00	SPY	ETF	102.63	102.82	102.39	102.8	14167062.0
2009-09-08 10:30:00	SPY	ETF	102.8	103.02	102.8	102.98	10259083.0
2009-09-08 11:00:00	SPY	ETF	102.98	103.03	102.81	102.95	8625129.0
2009-09-08 11:30:00	SPY	ETF	102.96	103.01	102.54	102.6625	6690436.0
2009-09-08 12:00:00	SPY	ETF	102.67	102.79	102.59	102.7383	3961178.0
2009-09-08 12:30:00	SPY	ETF	102.74	102.83	102.7	102.72	2339146.0
2009-09-08 13:00:00	SPY	ETF	102.72	102.81	102.53	102.68	3502454.0
2009-09-08 13:30:00	SPY	ETF	102.6897	102.755	102.51	102.71	4998796.0
2009-09-08 14:00:00	SPY	ETF	102.719	102.84	102.6	102.76	5623669.0
2009-09-08 14:30:00	SPY	ETF	102.77	102.99	102.76	102.89	7274256.0
2009-09-08 15:00:00	SPY	ETF	102.88	102.94	102.7012	102.9	8020002.0
2009-09-08 15:30:00	SPY	ETF	102.91	103.01	102.83	102.9	17004372.0
2009-09-08 16:00:00	SPY	ETF	102.89	103.0	102.0762	102.97	8706105.0
2009-09-08 16:30:00	SPY	ETF	102.96	102.96	102.0762	102.74	1415277.0
2009-09-08 17:00:00	SPY	ETF	102.74	102.82	102.7	102.79	107390.0
2009-09-08 17:30:00	SPY	ETF	102.79	102.79	102.74	102.79	27113.0
2009-09-08 18:00:00	SPY	ETF	102.79	102.89	102.74	102.79	46685.0
2009-09-08 18:30:00	SPY	ETF	102.81	102.81	102.79	102.79	7087.0
2009-09-08 19:00:00	SPY	ETF	102.81	102.88	102.8	102.83	21184.0
2009-09-08 19:30:00	SPY	ETF	102.83	102.9	102.83	102.85	46135.0
2009-09-08 04:00:00	QQQ	ETF	40.65	40.73	40.65	40.73	1319.0
2009-09-08 05:30:00	QQQ	ETF	40.73	40.73	40.68	40.68	3000.0
2009-09-08 06:30:00	QQQ	ETF	40.66	40.67	40.66	40.67	900.0
2009-09-08 07:00:00	QQQ	ETF	40.65	40.73	40.65	40.73	124920.0
2009-09-08 07:30:00	QQQ	ETF	40.71	40.73	40.66	40.69	101400.0
2009-09-08 08:00:00	QQQ	ETF	40.67	40.78	40.56	40.62	231607.0
2009-09-08 08:30:00	QQQ	ETF	40.61	40.65	40.6	40.64	106278.0
2009-09-08 09:00:00	QQQ	ETF	40.65	40.69	40.64	40.66	839687.0
2009-09-08 09:30:00	QQQ	ETF	40.65	40.78	40.5	40.55	11958978.0
2009-09-08 10:00:00	QQQ	ETF	40.552	40.63	40.48	40.6	9755797.0
2009-09-08 10:30:00	QQQ	ETF	40.6	40.71	40.59	40.69	5556352.0
2009-09-08 11:00:00	QQQ	ETF	40.68	40.72	40.59	40.6601	3061246.0
2009-09-08 11:30:00	QQQ	ETF	40.66	40.67	40.5	40.55	4453060.0
2009-09-08 12:00:00	QQQ	ETF	40.54	40.61	40.52	40.596	1926962.0
2009-09-08 12:30:00	QQQ	ETF	40.5976	40.61	40.53	40.57	788482.0
2009-09-08 13:00:00	QQQ	ETF	40.56	40.6	40.49	40.57	2087936.0
2009-09-08 13:30:00	QQQ	ETF	40.5699	40.58	40.46	40.5599	1906043.0
2009-09-08 14:00:00	QQQ	ETF	40.5595	40.62	40.49	40.589	2408825.0

> showing 50 of 7,626 rows — these rows as CSV

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