PREVIEW / etf_30min / 2009-03-05

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-05.parquet
  size:    212 KB
  rows:    7,147

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-03-05 04:00:00	SPY	ETF	70.73	70.73	70.65	70.65	3574.0
2009-03-05 04:30:00	SPY	ETF	70.6	70.82	70.6	70.82	1350.0
2009-03-05 05:00:00	SPY	ETF	70.88	70.88	70.88	70.88	100.0
2009-03-05 05:30:00	SPY	ETF	70.69	70.73	70.49	70.49	13413.0
2009-03-05 06:00:00	SPY	ETF	70.43	70.5	69.91	70.06	47045.0
2009-03-05 06:30:00	SPY	ETF	70.09	70.27	70.04	70.27	77400.0
2009-03-05 07:00:00	SPY	ETF	70.27	70.36	69.85	69.91	747165.0
2009-03-05 07:30:00	SPY	ETF	69.91	70.26	69.88	70.1	1031699.0
2009-03-05 08:00:00	SPY	ETF	70.1	70.8	69.87	70.09	3600619.0
2009-03-05 08:30:00	SPY	ETF	70.1	70.37	69.68	69.79	5177326.0
2009-03-05 09:00:00	SPY	ETF	69.77	70.15	69.76	70.1	2625053.0
2009-03-05 09:30:00	SPY	ETF	70.1	70.75	69.98	70.48	44065877.0
2009-03-05 10:00:00	SPY	ETF	70.49	70.87	69.95	70.1894	39952639.0
2009-03-05 10:30:00	SPY	ETF	70.19	70.47	69.71	69.76	29313446.0
2009-03-05 11:00:00	SPY	ETF	69.75	69.95	69.07	69.17	32419022.0
2009-03-05 11:30:00	SPY	ETF	69.17	69.6	69.01	69.19	25242286.0
2009-03-05 12:00:00	SPY	ETF	69.18	70.11	68.8	69.38	23804375.0
2009-03-05 12:30:00	SPY	ETF	69.39	69.49	68.94	69.07	17459943.0
2009-03-05 13:00:00	SPY	ETF	69.07	69.77	69.0	69.41	26556337.0
2009-03-05 13:30:00	SPY	ETF	69.41	69.43	68.88	69.1701	29081122.0
2009-03-05 14:00:00	SPY	ETF	69.18	69.6	68.64	68.76	30502984.0
2009-03-05 14:30:00	SPY	ETF	68.77	71.73	68.58	68.69	28911441.0
2009-03-05 15:00:00	SPY	ETF	68.69	71.73	68.66	68.85	34537150.0
2009-03-05 15:30:00	SPY	ETF	68.85	68.94	68.17	68.77	76874291.0
2009-03-05 16:00:00	SPY	ETF	68.79	71.73	68.7137	69.1	19844256.0
2009-03-05 16:30:00	SPY	ETF	69.1	71.7308	69.08	69.2	5801165.0
2009-03-05 17:00:00	SPY	ETF	69.2	69.3	69.17	69.25	329909.0
2009-03-05 17:30:00	SPY	ETF	69.25	69.27	69.19	69.21	58336.0
2009-03-05 18:00:00	SPY	ETF	69.22	69.3	69.11	69.11	106946.0
2009-03-05 18:30:00	SPY	ETF	69.09	69.16	69.05	69.05	80971.0
2009-03-05 19:00:00	SPY	ETF	69.05	69.14	69.03	69.13	101560.0
2009-03-05 19:30:00	SPY	ETF	69.14	69.15	69.06	69.08	90546.0
2009-03-05 04:00:00	QQQ	ETF	27.05	27.05	27.05	27.05	400.0
2009-03-05 04:30:00	QQQ	ETF	26.98	27.09	26.98	27.09	1400.0
2009-03-05 05:30:00	QQQ	ETF	27.05	27.05	27.01	27.01	2365.0
2009-03-05 06:00:00	QQQ	ETF	27.01	27.01	26.84	26.86	1800.0
2009-03-05 06:30:00	QQQ	ETF	26.91	26.92	26.91	26.92	5500.0
2009-03-05 07:00:00	QQQ	ETF	26.93	26.96	26.78	26.78	251500.0
2009-03-05 07:30:00	QQQ	ETF	26.83	26.88	26.79	26.83	363156.0
2009-03-05 08:00:00	QQQ	ETF	26.91	27.03	26.83	26.97	2532197.0
2009-03-05 08:30:00	QQQ	ETF	26.96	27.06	26.87	26.92	1079705.0
2009-03-05 09:00:00	QQQ	ETF	26.93	27.04	26.93	27.02	683239.0
2009-03-05 09:30:00	QQQ	ETF	27.03	27.24	26.86	27.1	20676623.0
2009-03-05 10:00:00	QQQ	ETF	27.1	27.23	26.9	26.9488	17469216.0
2009-03-05 10:30:00	QQQ	ETF	26.94	27.05	26.79	26.81	9108584.0
2009-03-05 11:00:00	QQQ	ETF	26.8	26.89	26.5801	26.62	9554171.0
2009-03-05 11:30:00	QQQ	ETF	26.62	26.8	26.6	26.66	9007862.0
2009-03-05 12:00:00	QQQ	ETF	26.66	26.73	26.52	26.73	7679178.0
2009-03-05 12:30:00	QQQ	ETF	26.73	26.78	26.59	26.63	8753704.0
2009-03-05 13:00:00	QQQ	ETF	26.63	26.84	26.61	26.76	8931829.0

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

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