PREVIEW / etf_30min / 2009-01-07

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-07.parquet
  size:    205 KB
  rows:    6,729

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-01-07 04:00:00	SPY	ETF	92.48	92.52	92.45	92.45	3300.0
2009-01-07 04:30:00	SPY	ETF	92.62	92.62	92.62	92.62	800.0
2009-01-07 05:00:00	SPY	ETF	92.62	92.84	92.55	92.84	2170.0
2009-01-07 05:30:00	SPY	ETF	92.73	92.8	92.73	92.77	1400.0
2009-01-07 06:00:00	SPY	ETF	92.73	92.88	92.73	92.88	1600.0
2009-01-07 06:30:00	SPY	ETF	92.77	92.82	92.64	92.73	76130.0
2009-01-07 07:00:00	SPY	ETF	92.7	92.73	92.61	92.69	253487.0
2009-01-07 07:30:00	SPY	ETF	92.67	92.71	92.46	92.52	102131.0
2009-01-07 08:00:00	SPY	ETF	92.5	92.85	91.94	92.0	1924147.0
2009-01-07 08:30:00	SPY	ETF	92.0	92.35	91.88	92.17	1475861.0
2009-01-07 09:00:00	SPY	ETF	92.17	92.18	91.61	91.99	2936105.0
2009-01-07 09:30:00	SPY	ETF	92.0	92.26	91.65	92.09	28335580.0
2009-01-07 10:00:00	SPY	ETF	92.08	92.2292	91.36	91.58	23264575.0
2009-01-07 10:30:00	SPY	ETF	91.57	91.65	91.25	91.5	18008172.0
2009-01-07 11:00:00	SPY	ETF	91.5	91.78	91.36	91.64	13411046.0
2009-01-07 11:30:00	SPY	ETF	91.64	92.11	91.62	92.01	13353353.0
2009-01-07 12:00:00	SPY	ETF	92.01	92.02	91.55	91.6299	11784749.0
2009-01-07 12:30:00	SPY	ETF	91.63	91.76	91.35	91.4	8805043.0
2009-01-07 13:00:00	SPY	ETF	91.41	91.68	91.33	91.6	11156952.0
2009-01-07 13:30:00	SPY	ETF	91.59	91.75	90.93	90.9501	15386251.0
2009-01-07 14:00:00	SPY	ETF	90.95	91.07	90.67	90.8	16691584.0
2009-01-07 14:30:00	SPY	ETF	90.8	90.92	90.54	90.6	24192951.0
2009-01-07 15:00:00	SPY	ETF	90.6	90.68	90.2	90.63	28215231.0
2009-01-07 15:30:00	SPY	ETF	90.64	91.55	90.25	90.7	36880922.0
2009-01-07 16:00:00	SPY	ETF	90.69	93.4863	90.37	90.8	14031278.0
2009-01-07 16:30:00	SPY	ETF	90.82	91.05	90.76	90.99	2545109.0
2009-01-07 17:00:00	SPY	ETF	91.0	91.03	90.94	90.95	109506.0
2009-01-07 17:30:00	SPY	ETF	90.97	91.05	90.93	90.97	296140.0
2009-01-07 18:00:00	SPY	ETF	90.97	90.98	90.84	90.84	84182.0
2009-01-07 18:30:00	SPY	ETF	90.84	90.92	90.82	90.85	39180.0
2009-01-07 19:00:00	SPY	ETF	90.85	90.98	90.85	90.97	43368.0
2009-01-07 19:30:00	SPY	ETF	90.94	90.96	90.85	90.87	32790.0
2009-01-07 04:00:00	QQQ	ETF	31.05	31.05	31.05	31.05	500.0
2009-01-07 04:30:00	QQQ	ETF	31.07	31.07	31.07	31.07	300.0
2009-01-07 05:00:00	QQQ	ETF	31.15	31.15	31.15	31.15	100.0
2009-01-07 05:30:00	QQQ	ETF	31.17	31.17	31.12	31.12	200.0
2009-01-07 06:00:00	QQQ	ETF	31.19	31.19	31.14	31.14	200.0
2009-01-07 06:30:00	QQQ	ETF	31.1	31.1	31.1	31.1	1000.0
2009-01-07 07:00:00	QQQ	ETF	31.08	31.13	31.08	31.09	5800.0
2009-01-07 07:30:00	QQQ	ETF	31.09	31.1	30.99	31.0	27185.0
2009-01-07 08:00:00	QQQ	ETF	31.02	31.06	30.77	30.83	1130565.0
2009-01-07 08:30:00	QQQ	ETF	30.81	30.96	30.76	30.87	1106007.0
2009-01-07 09:00:00	QQQ	ETF	30.86	30.86	30.6	30.82	3477260.0
2009-01-07 09:30:00	QQQ	ETF	30.81	30.9	30.66	30.81	16436802.0
2009-01-07 10:00:00	QQQ	ETF	30.81	30.85	30.47	30.61	17588466.0
2009-01-07 10:30:00	QQQ	ETF	30.6	30.68	30.49	30.63	7956710.0
2009-01-07 11:00:00	QQQ	ETF	30.63	30.76	30.6	30.69	7275438.0
2009-01-07 11:30:00	QQQ	ETF	30.69	30.87	30.67	30.83	6171221.0
2009-01-07 12:00:00	QQQ	ETF	30.8299	30.83	30.7	30.73	4608902.0
2009-01-07 12:30:00	QQQ	ETF	30.73	30.79	30.62	30.642	7247667.0

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

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