PREVIEW / etf_30min / 2007-04-11

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-11.parquet
  size:    108 KB
  rows:    3,740

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-04-11 06:00:00	SPY	ETF	144.71	144.73	144.71	144.73	8000.0
2007-04-11 06:30:00	SPY	ETF	144.78	144.78	144.78	144.78	2000.0
2007-04-11 07:00:00	SPY	ETF	144.77	144.77	144.74	144.76	17700.0
2007-04-11 07:30:00	SPY	ETF	144.74	144.77	144.74	144.77	4600.0
2007-04-11 08:00:00	SPY	ETF	144.74	144.85	144.74	144.84	203900.0
2007-04-11 08:30:00	SPY	ETF	144.8	144.89	144.8	144.88	208400.0
2007-04-11 09:00:00	SPY	ETF	144.88	144.89	144.81	144.81	395075.0
2007-04-11 09:30:00	SPY	ETF	144.82	144.86	144.41	144.49	8172812.0
2007-04-11 10:00:00	SPY	ETF	144.49	144.61	144.3	144.42	6723577.0
2007-04-11 10:30:00	SPY	ETF	144.41	144.47	143.81	143.96	13423305.0
2007-04-11 11:00:00	SPY	ETF	143.96	144.17	143.94	144.1	8664731.0
2007-04-11 11:30:00	SPY	ETF	144.1	144.14	143.96	144.12	3418216.0
2007-04-11 12:00:00	SPY	ETF	144.12	144.28	144.11	144.21	5570512.0
2007-04-11 12:30:00	SPY	ETF	144.21	144.24	144.09	144.2	1605781.0
2007-04-11 13:00:00	SPY	ETF	144.2	144.45	144.13	144.35	5039946.0
2007-04-11 13:30:00	SPY	ETF	144.35	144.44	144.21	144.23	3133394.0
2007-04-11 14:00:00	SPY	ETF	144.23	144.23	143.78	143.94	17742914.0
2007-04-11 14:30:00	SPY	ETF	143.94	143.94	143.54	143.78	11914226.0
2007-04-11 15:00:00	SPY	ETF	143.79	143.99	143.69	143.85	6960629.0
2007-04-11 15:30:00	SPY	ETF	143.84	144.03	143.78	143.83	6305513.0
2007-04-11 16:00:00	SPY	ETF	143.84	144.02	143.81	143.95	2361000.0
2007-04-11 16:30:00	SPY	ETF	143.93	144.02	143.9	144.0	2367600.0
2007-04-11 17:00:00	SPY	ETF	143.898	143.98	143.898	143.93	204100.0
2007-04-11 17:30:00	SPY	ETF	143.91	143.91	143.85	143.85	10400.0
2007-04-11 18:00:00	SPY	ETF	143.9	143.94	143.9	143.93	175600.0
2007-04-11 18:30:00	SPY	ETF	143.93	143.93	143.92	143.92	500.0
2007-04-11 19:00:00	SPY	ETF	143.92	143.92	143.92	143.92	100.0
2007-04-11 19:30:00	SPY	ETF	143.93	143.95	143.93	143.95	2800.0
2007-04-11 07:00:00	QQQ	ETF	44.7	44.7	44.67	44.68	75500.0
2007-04-11 07:30:00	QQQ	ETF	44.68	44.68	44.66	44.68	102225.0
2007-04-11 08:00:00	QQQ	ETF	44.67	44.71	44.67	44.7	88937.0
2007-04-11 08:30:00	QQQ	ETF	44.68	44.71	44.68	44.68	215375.0
2007-04-11 09:00:00	QQQ	ETF	44.68	44.69	44.65	44.65	379519.0
2007-04-11 09:30:00	QQQ	ETF	44.64	44.66	44.44	44.47	17682700.0
2007-04-11 10:00:00	QQQ	ETF	44.48	44.52	44.31	44.38	12798000.0
2007-04-11 10:30:00	QQQ	ETF	44.39	44.41	44.2	44.26	11669000.0
2007-04-11 11:00:00	QQQ	ETF	44.25	44.37	44.24	44.36	7332000.0
2007-04-11 11:30:00	QQQ	ETF	44.35	44.37	44.31	44.36	3785300.0
2007-04-11 12:00:00	QQQ	ETF	44.35	44.42	44.35	44.36	4179200.0
2007-04-11 12:30:00	QQQ	ETF	44.36	44.38	44.31	44.35	3130000.0
2007-04-11 13:00:00	QQQ	ETF	44.35	44.46	44.33	44.42	4714300.0
2007-04-11 13:30:00	QQQ	ETF	44.42	44.45	44.36	44.37	3263600.0
2007-04-11 14:00:00	QQQ	ETF	44.36	44.37	44.18	44.25	13688800.0
2007-04-11 14:30:00	QQQ	ETF	44.25	44.26	44.07	44.17	10661900.0
2007-04-11 15:00:00	QQQ	ETF	44.17	44.26	44.13	44.2	5573400.0
2007-04-11 15:30:00	QQQ	ETF	44.2	44.27	44.18	44.21	7472800.0
2007-04-11 16:00:00	QQQ	ETF	44.22	44.24	44.17	44.19	3908643.0
2007-04-11 16:30:00	QQQ	ETF	44.19	44.21	44.18	44.2	420056.0
2007-04-11 17:00:00	QQQ	ETF	44.21	44.21	44.19	44.2	14650.0
2007-04-11 17:30:00	QQQ	ETF	44.2	44.2	44.17	44.2	20900.0

> showing 50 of 3,740 rows — these rows as CSV

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