PREVIEW / etf_30min / 2007-10-10

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-10.parquet
  size:    125 KB
  rows:    4,741

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
2007-10-10 04:00:00	SPY	ETF	156.17	156.17	156.15	156.15	3100.0
2007-10-10 05:00:00	SPY	ETF	156.14	156.14	156.14	156.14	2000.0
2007-10-10 05:30:00	SPY	ETF	156.17	156.17	156.17	156.17	12500.0
2007-10-10 06:00:00	SPY	ETF	156.16	156.16	156.16	156.16	24900.0
2007-10-10 06:30:00	SPY	ETF	156.18	156.23	156.18	156.23	74800.0
2007-10-10 07:00:00	SPY	ETF	156.29	156.29	156.16	156.18	44400.0
2007-10-10 07:30:00	SPY	ETF	156.19	156.19	156.03	156.11	247500.0
2007-10-10 08:00:00	SPY	ETF	156.13	156.18	156.03	156.09	993200.0
2007-10-10 08:30:00	SPY	ETF	156.11	156.48	156.07	156.09	296900.0
2007-10-10 09:00:00	SPY	ETF	156.08	156.48	156.0	156.03	531500.0
2007-10-10 09:30:00	SPY	ETF	156.04	156.12	155.76	155.79	11149724.0
2007-10-10 10:00:00	SPY	ETF	155.8	155.915	155.67	155.84	9805200.0
2007-10-10 10:30:00	SPY	ETF	155.84	155.95	155.67	155.72	4988000.0
2007-10-10 11:00:00	SPY	ETF	155.71	156.11	155.71	156.05	6044200.0
2007-10-10 11:30:00	SPY	ETF	156.05	156.17	155.76	155.81	5985992.0
2007-10-10 12:00:00	SPY	ETF	155.82	155.91	155.66	155.8	5392000.0
2007-10-10 12:30:00	SPY	ETF	155.81	155.96	155.71	155.82	3265598.0
2007-10-10 13:00:00	SPY	ETF	155.82	155.83	155.41	155.42	8119300.0
2007-10-10 13:30:00	SPY	ETF	155.42	155.63	155.42	155.62	6380500.0
2007-10-10 14:00:00	SPY	ETF	155.63	155.86	155.53	155.82	4709800.0
2007-10-10 14:30:00	SPY	ETF	155.82	156.15	155.81	156.09	6984700.0
2007-10-10 15:00:00	SPY	ETF	156.09	156.44	156.09	156.3	9090100.0
2007-10-10 15:30:00	SPY	ETF	156.3	156.32	155.99	156.03	11004500.0
2007-10-10 16:00:00	SPY	ETF	156.03	156.3988	156.02	156.15	3866700.0
2007-10-10 16:30:00	SPY	ETF	156.15	156.16	155.85	156.09	681100.0
2007-10-10 17:00:00	SPY	ETF	156.09	156.12	156.08	156.12	18000.0
2007-10-10 17:30:00	SPY	ETF	156.14	156.15	156.13	156.15	17400.0
2007-10-10 18:00:00	SPY	ETF	156.15	156.36	156.15	156.3	175800.0
2007-10-10 18:30:00	SPY	ETF	156.32	156.32	156.28	156.3	6500.0
2007-10-10 19:00:00	SPY	ETF	156.3	156.3	156.24	156.24	21900.0
2007-10-10 19:30:00	SPY	ETF	156.25	156.25	156.23	156.25	15300.0
2007-10-10 06:30:00	QQQ	ETF	53.37	53.4	53.37	53.4	6500.0
2007-10-10 07:00:00	QQQ	ETF	53.4	53.4	53.38	53.38	15922.0
2007-10-10 07:30:00	QQQ	ETF	53.38	53.4	53.33	53.35	72934.0
2007-10-10 08:00:00	QQQ	ETF	53.36	53.43	53.34	53.41	518059.0
2007-10-10 08:30:00	QQQ	ETF	53.4	53.43	53.4	53.41	302239.0
2007-10-10 09:00:00	QQQ	ETF	53.41	53.43	53.34	53.39	1249818.0
2007-10-10 09:30:00	QQQ	ETF	53.39	53.39	53.29	53.32	9244602.0
2007-10-10 10:00:00	QQQ	ETF	53.32	53.38	53.27	53.36	9571146.0
2007-10-10 10:30:00	QQQ	ETF	53.36	53.44	53.3	53.32	5265765.0
2007-10-10 11:00:00	QQQ	ETF	53.32	53.449	53.32	53.42	5544360.0
2007-10-10 11:30:00	QQQ	ETF	53.42	53.47	53.33	53.341	5598805.0
2007-10-10 12:00:00	QQQ	ETF	53.341	53.39	53.27	53.33	6693003.0
2007-10-10 12:30:00	QQQ	ETF	53.34	53.41	53.3374	53.38	2288227.0
2007-10-10 13:00:00	QQQ	ETF	53.38	53.38	53.21	53.22	5036229.0
2007-10-10 13:30:00	QQQ	ETF	53.22	53.32	53.2101	53.32	6026214.0
2007-10-10 14:00:00	QQQ	ETF	53.32	53.37	53.25	53.3685	3588952.0
2007-10-10 14:30:00	QQQ	ETF	53.3601	53.47	53.35	53.44	5854410.0
2007-10-10 15:00:00	QQQ	ETF	53.44	53.57	53.44	53.51	8537706.0
2007-10-10 15:30:00	QQQ	ETF	53.52	53.57	53.48	53.5	10887736.0

> showing 50 of 4,741 rows — these rows as CSV

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