PREVIEW / etf_30min / 2007-03-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-27.parquet
  size:    103 KB
  rows:    3,675

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-03-27 06:00:00	SPY	ETF	143.1	143.1	143.1	143.1	100.0
2007-03-27 06:30:00	SPY	ETF	143.07	143.08	143.05	143.05	8200.0
2007-03-27 07:00:00	SPY	ETF	143.1	143.18	143.1	143.17	14400.0
2007-03-27 07:30:00	SPY	ETF	143.19	143.28	143.14	143.27	114500.0
2007-03-27 08:00:00	SPY	ETF	143.27	143.27	143.19	143.27	117000.0
2007-03-27 08:30:00	SPY	ETF	143.26	143.27	143.1	143.13	233700.0
2007-03-27 09:00:00	SPY	ETF	143.13	143.19	143.05	143.14	288000.0
2007-03-27 09:30:00	SPY	ETF	143.12	143.16	142.63	142.83	9841400.0
2007-03-27 10:00:00	SPY	ETF	142.82	143.05	142.56	142.67	12767600.0
2007-03-27 10:30:00	SPY	ETF	142.67	143.07	142.5	142.89	10863852.0
2007-03-27 11:00:00	SPY	ETF	142.89	142.92	142.43	142.48	6744386.0
2007-03-27 11:30:00	SPY	ETF	142.48	142.74	142.39	142.63	4560050.0
2007-03-27 12:00:00	SPY	ETF	142.63	142.82	142.54	142.71	3063650.0
2007-03-27 12:30:00	SPY	ETF	142.71	142.88	142.69	142.8	3560250.0
2007-03-27 13:00:00	SPY	ETF	142.8	142.94	142.78	142.83	5513200.0
2007-03-27 13:30:00	SPY	ETF	142.83	142.9	142.72	142.77	3351300.0
2007-03-27 14:00:00	SPY	ETF	142.77	142.81	142.6	142.6	9827400.0
2007-03-27 14:30:00	SPY	ETF	142.6	142.85	142.58	142.82	6635057.0
2007-03-27 15:00:00	SPY	ETF	142.82	142.92	142.73	142.88	4431750.0
2007-03-27 15:30:00	SPY	ETF	142.88	142.98	142.7	142.71	8490182.0
2007-03-27 16:00:00	SPY	ETF	142.71	143.04	142.6	142.76	1120700.0
2007-03-27 16:30:00	SPY	ETF	142.77	142.8	141.86	142.43	4147100.0
2007-03-27 17:00:00	SPY	ETF	142.43	142.74	142.1	142.43	2417300.0
2007-03-27 17:30:00	SPY	ETF	142.42	142.42	142.2	142.32	422200.0
2007-03-27 18:00:00	SPY	ETF	142.35	142.43	142.29	142.38	586400.0
2007-03-27 18:30:00	SPY	ETF	142.36	142.4	142.33	142.34	69200.0
2007-03-27 19:00:00	SPY	ETF	142.33	142.38	142.33	142.37	24500.0
2007-03-27 19:30:00	SPY	ETF	142.38	142.42	142.35	142.42	25400.0
2007-03-27 04:00:00	QQQ	ETF	44.19	44.19	44.19	44.19	300.0
2007-03-27 06:00:00	QQQ	ETF	44.15	44.15	44.15	44.15	100.0
2007-03-27 06:30:00	QQQ	ETF	44.14	44.14	44.14	44.14	300.0
2007-03-27 07:00:00	QQQ	ETF	44.17	44.2	44.17	44.19	52273.0
2007-03-27 07:30:00	QQQ	ETF	44.2	44.24	44.19	44.23	64707.0
2007-03-27 08:00:00	QQQ	ETF	44.25	44.25	44.22	44.24	39089.0
2007-03-27 08:30:00	QQQ	ETF	44.24	44.24	44.2	44.2	182353.0
2007-03-27 09:00:00	QQQ	ETF	44.21	44.22	44.19	44.21	129603.0
2007-03-27 09:30:00	QQQ	ETF	44.21	44.24	44.12	44.12	8536000.0
2007-03-27 10:00:00	QQQ	ETF	44.13	44.18	44.05	44.1	9018700.0
2007-03-27 10:30:00	QQQ	ETF	44.1	44.17	44.04	44.16	5437700.0
2007-03-27 11:00:00	QQQ	ETF	44.15	44.15	44.02	44.03	6442700.0
2007-03-27 11:30:00	QQQ	ETF	44.03	44.12	43.95	44.05	6941900.0
2007-03-27 12:00:00	QQQ	ETF	44.05	44.09	44.02	44.05	2701500.0
2007-03-27 12:30:00	QQQ	ETF	44.05	44.11	44.04	44.09	1802000.0
2007-03-27 13:00:00	QQQ	ETF	44.09	44.15	44.07	44.12	2081400.0
2007-03-27 13:30:00	QQQ	ETF	44.13	44.14	44.08	44.1	1970200.0
2007-03-27 14:00:00	QQQ	ETF	44.1	44.11	43.99	43.99	4721500.0
2007-03-27 14:30:00	QQQ	ETF	43.99	44.08	43.98	44.08	3405100.0
2007-03-27 15:00:00	QQQ	ETF	44.08	44.33	44.05	44.1	5970700.0
2007-03-27 15:30:00	QQQ	ETF	44.09	44.14	43.99	43.99	8532100.0
2007-03-27 16:00:00	QQQ	ETF	43.99	44.1301	43.97	43.99	2532000.0

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

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