PREVIEW / etf_30min / 2009-06-19

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-19.parquet
  size:    215 KB
  rows:    7,036

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-19 04:00:00	SPY	ETF	91.98	92.04	91.98	91.99	2600.0
2009-06-19 04:30:00	SPY	ETF	92.0	92.0	92.0	92.0	100.0
2009-06-19 05:00:00	SPY	ETF	91.98	91.98	91.98	91.98	2000.0
2009-06-19 05:30:00	SPY	ETF	92.29	92.34	92.29	92.34	10200.0
2009-06-19 06:00:00	SPY	ETF	92.31	92.35	92.31	92.35	1200.0
2009-06-19 06:30:00	SPY	ETF	92.4	92.42	92.35	92.37	43200.0
2009-06-19 07:00:00	SPY	ETF	92.4	92.46	92.24	92.27	755488.0
2009-06-19 07:30:00	SPY	ETF	92.28	92.41	92.16	92.37	643581.0
2009-06-19 08:00:00	SPY	ETF	92.37	92.53	92.3	92.44	873710.0
2009-06-19 08:30:00	SPY	ETF	92.44	92.66	92.08	92.51	1521786.0
2009-06-19 09:00:00	SPY	ETF	92.5	92.65	92.42	92.58	2800733.0
2009-06-19 09:30:00	SPY	ETF	92.58	92.7	92.425	92.55	26652882.0
2009-06-19 10:00:00	SPY	ETF	92.56	92.61	92.2	92.3322	13963230.0
2009-06-19 10:30:00	SPY	ETF	92.34	92.68	92.31	92.58	10385560.0
2009-06-19 11:00:00	SPY	ETF	92.5899	92.68	92.37	92.405	10339262.0
2009-06-19 11:30:00	SPY	ETF	92.41	92.55	92.24	92.36	8627191.0
2009-06-19 12:00:00	SPY	ETF	92.35	92.38	91.9	91.95	11108956.0
2009-06-19 12:30:00	SPY	ETF	91.95	92.28	91.81	91.84	9773606.0
2009-06-19 13:00:00	SPY	ETF	91.84	91.99	91.82	91.91	6999781.0
2009-06-19 13:30:00	SPY	ETF	91.92	92.14	91.87	91.91	10213130.0
2009-06-19 14:00:00	SPY	ETF	91.91	91.97	91.52	91.62	15995711.0
2009-06-19 14:30:00	SPY	ETF	91.62	91.88	91.605	91.84	13710059.0
2009-06-19 15:00:00	SPY	ETF	91.84	92.31	91.73	92.3	14931625.0
2009-06-19 15:30:00	SPY	ETF	92.3	92.38	91.93	91.97	24840178.0
2009-06-19 16:00:00	SPY	ETF	91.98	92.4	91.82	91.97	10871022.0
2009-06-19 16:30:00	SPY	ETF	91.97	92.03	91.9	91.96	1908595.0
2009-06-19 17:00:00	SPY	ETF	91.9	91.97	91.86	91.86	4747088.0
2009-06-19 17:30:00	SPY	ETF	91.86	91.91	91.83	91.87	1290527.0
2009-06-19 18:00:00	SPY	ETF	91.88	92.04	91.85	91.9	78102.0
2009-06-19 18:30:00	SPY	ETF	91.9	91.93	91.88	91.88	7600.0
2009-06-19 19:00:00	SPY	ETF	91.9	91.9	91.89	91.9	1720.0
2009-06-19 19:30:00	SPY	ETF	91.88	91.93	91.87	91.89	12750.0
2009-06-19 06:30:00	QQQ	ETF	35.97	35.97	35.97	35.97	100.0
2009-06-19 07:00:00	QQQ	ETF	35.96	35.99	35.91	35.95	203738.0
2009-06-19 07:30:00	QQQ	ETF	35.94	36.01	35.87	36.0	306750.0
2009-06-19 08:00:00	QQQ	ETF	36.0	36.04	35.97	36.02	408305.0
2009-06-19 08:30:00	QQQ	ETF	36.03	36.1	36.02	36.04	784804.0
2009-06-19 09:00:00	QQQ	ETF	36.03	36.09	36.02	36.05	1037261.0
2009-06-19 09:30:00	QQQ	ETF	36.04	36.32	36.03	36.28	19999399.0
2009-06-19 10:00:00	QQQ	ETF	36.28	36.3	36.17	36.22	9496877.0
2009-06-19 10:30:00	QQQ	ETF	36.21	36.36	36.2	36.34	5398355.0
2009-06-19 11:00:00	QQQ	ETF	36.34	36.36	35.9768	36.26	4888514.0
2009-06-19 11:30:00	QQQ	ETF	36.26	36.3	36.2	36.24	5449034.0
2009-06-19 12:00:00	QQQ	ETF	36.24	36.25	36.05	36.07	6349610.0
2009-06-19 12:30:00	QQQ	ETF	36.07	36.125	36.03	36.05	6241940.0
2009-06-19 13:00:00	QQQ	ETF	36.05	36.12	36.03	36.08	2929559.0
2009-06-19 13:30:00	QQQ	ETF	36.08	36.17	36.07	36.11	7939858.0
2009-06-19 14:00:00	QQQ	ETF	36.109	36.135	35.9101	35.96	7832915.0
2009-06-19 14:30:00	QQQ	ETF	35.96	36.0695	35.95	36.04	4827500.0
2009-06-19 15:00:00	QQQ	ETF	36.04	36.23	36.0	36.22	8484226.0

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

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