PREVIEW / etf_30min / 2009-06-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-17.parquet
  size:    221 KB
  rows:    7,234

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-06-17 04:00:00	SPY	ETF	91.75	91.81	91.75	91.81	700.0
2009-06-17 05:00:00	SPY	ETF	91.75	91.75	91.67	91.67	1740.0
2009-06-17 05:30:00	SPY	ETF	91.63	91.72	91.63	91.72	7000.0
2009-06-17 06:00:00	SPY	ETF	91.56	91.74	91.56	91.7	3000.0
2009-06-17 06:30:00	SPY	ETF	91.68	91.7	91.49	91.7	116750.0
2009-06-17 07:00:00	SPY	ETF	91.64	92.04	91.64	92.02	549346.0
2009-06-17 07:30:00	SPY	ETF	92.0	92.06	91.28	91.36	2151377.0
2009-06-17 08:00:00	SPY	ETF	91.36	92.03	91.33	91.47	2989883.0
2009-06-17 08:30:00	SPY	ETF	91.48	92.0	91.4	91.71	2125901.0
2009-06-17 09:00:00	SPY	ETF	91.7	91.71	91.35	91.59	3314500.0
2009-06-17 09:30:00	SPY	ETF	91.6	91.81	91.17	91.22	30298933.0
2009-06-17 10:00:00	SPY	ETF	91.22	91.65	91.14	91.6	23736120.0
2009-06-17 10:30:00	SPY	ETF	91.28	91.28	90.83	91.12	21084607.0
2009-06-17 11:00:00	SPY	ETF	91.1282	91.57	91.09	91.46	16347040.0
2009-06-17 11:30:00	SPY	ETF	91.47	91.59	91.0	91.58	11216698.0
2009-06-17 12:00:00	SPY	ETF	91.57	92.03	91.55	91.88	13616377.0
2009-06-17 12:30:00	SPY	ETF	91.87	91.91	91.6	91.71	8878408.0
2009-06-17 13:00:00	SPY	ETF	91.7	91.93	91.61	91.93	5338946.0
2009-06-17 13:30:00	SPY	ETF	91.9212	92.31	91.87	92.12	12875387.0
2009-06-17 14:00:00	SPY	ETF	92.12	92.31	92.03	92.3	9219016.0
2009-06-17 14:30:00	SPY	ETF	92.3	92.33	91.76	91.89	10297077.0
2009-06-17 15:00:00	SPY	ETF	91.89	92.05	91.58	91.62	12584559.0
2009-06-17 15:30:00	SPY	ETF	91.61	91.86	91.41	91.57	27643078.0
2009-06-17 16:00:00	SPY	ETF	91.57	91.9604	91.39	91.44	4953917.0
2009-06-17 16:30:00	SPY	ETF	91.44	91.55	91.44	91.52	2310835.0
2009-06-17 17:00:00	SPY	ETF	91.54	91.56	91.45	91.45	222521.0
2009-06-17 17:30:00	SPY	ETF	91.48	91.5	91.44	91.49	46470.0
2009-06-17 18:00:00	SPY	ETF	91.49	91.56	91.48	91.55	26982.0
2009-06-17 18:30:00	SPY	ETF	91.52	91.55	91.5	91.55	3200.0
2009-06-17 19:00:00	SPY	ETF	91.56	91.72	91.55	91.72	30569.0
2009-06-17 19:30:00	SPY	ETF	91.67	91.87	91.66	91.85	62986.0
2009-06-17 05:00:00	QQQ	ETF	35.59	35.61	35.59	35.61	200.0
2009-06-17 06:30:00	QQQ	ETF	35.61	35.62	35.58	35.6	3100.0
2009-06-17 07:00:00	QQQ	ETF	35.68	35.78	35.68	35.76	440643.0
2009-06-17 07:30:00	QQQ	ETF	35.8	35.8	35.6	35.62	399500.0
2009-06-17 08:00:00	QQQ	ETF	35.78	35.78	35.6	35.64	1863102.0
2009-06-17 08:30:00	QQQ	ETF	35.63	35.74	35.62	35.71	742587.0
2009-06-17 09:00:00	QQQ	ETF	35.71	35.71	35.6	35.68	967796.0
2009-06-17 09:30:00	QQQ	ETF	35.67	35.79	35.49	35.505	25387596.0
2009-06-17 10:00:00	QQQ	ETF	35.5	35.76	35.47	35.6005	16304545.0
2009-06-17 10:30:00	QQQ	ETF	35.6022	35.65	35.45	35.61	10688003.0
2009-06-17 11:00:00	QQQ	ETF	35.6	35.88	35.6	35.81	14180705.0
2009-06-17 11:30:00	QQQ	ETF	35.8101	35.86	35.75	35.84	7819624.0
2009-06-17 12:00:00	QQQ	ETF	35.85	36.04	35.8	35.96	8634251.0
2009-06-17 12:30:00	QQQ	ETF	35.96	35.99	35.88	35.9095	6166915.0
2009-06-17 13:00:00	QQQ	ETF	35.91	36.07	35.5	36.06	4140429.0
2009-06-17 13:30:00	QQQ	ETF	36.06	36.21	35.5	36.13	8162873.0
2009-06-17 14:00:00	QQQ	ETF	36.13	36.19	36.07	36.14	5093821.0
2009-06-17 14:30:00	QQQ	ETF	36.15	36.16	35.95	36.01	7137541.0
2009-06-17 15:00:00	QQQ	ETF	36.01	36.06	35.87	35.87	7033683.0

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

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