PREVIEW / etf_30min / 2008-04-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-07.parquet
  size:    160 KB
  rows:    5,857

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
2008-04-07 04:00:00	SPY	ETF	137.97	138.15	137.97	138.15	1700.0
2008-04-07 05:00:00	SPY	ETF	137.94	137.94	137.89	137.89	1200.0
2008-04-07 05:30:00	SPY	ETF	137.9	138.14	137.9	138.14	12800.0
2008-04-07 06:00:00	SPY	ETF	138.08	138.15	138.0	138.0	25600.0
2008-04-07 06:30:00	SPY	ETF	137.9	137.95	137.9	137.95	2900.0
2008-04-07 07:00:00	SPY	ETF	137.95	138.0	137.83	137.92	160100.0
2008-04-07 07:30:00	SPY	ETF	137.92	138.02	137.85	138.0	212800.0
2008-04-07 08:00:00	SPY	ETF	137.99	138.05	137.71	138.02	1355800.0
2008-04-07 08:30:00	SPY	ETF	138.02	138.03	137.35	137.84	1235700.0
2008-04-07 09:00:00	SPY	ETF	137.84	137.93	137.72	137.87	1017022.0
2008-04-07 09:30:00	SPY	ETF	137.87	138.05	137.0	137.89	14913952.0
2008-04-07 10:00:00	SPY	ETF	137.89	137.91	137.37	137.39	9823801.0
2008-04-07 10:30:00	SPY	ETF	137.39	137.67	137.3	137.64	6732300.0
2008-04-07 11:00:00	SPY	ETF	137.65	137.86	137.41	137.77	6974010.0
2008-04-07 11:30:00	SPY	ETF	137.76	138.24	137.75	138.11	12845781.0
2008-04-07 12:00:00	SPY	ETF	138.1	138.2	138.0	138.12	7500743.0
2008-04-07 12:30:00	SPY	ETF	138.12	138.57	138.07	138.39	9205595.0
2008-04-07 13:00:00	SPY	ETF	138.399	138.45	138.03	138.12	7676184.0
2008-04-07 13:30:00	SPY	ETF	138.14	138.245	137.78	137.95	7172492.0
2008-04-07 14:00:00	SPY	ETF	137.95	138.0	137.43	137.4301	9759578.0
2008-04-07 14:30:00	SPY	ETF	137.43	137.54	137.13	137.22	12075549.0
2008-04-07 15:00:00	SPY	ETF	137.22	137.3	136.83	137.27	14303780.0
2008-04-07 15:30:00	SPY	ETF	137.26	137.54	136.74	137.05	20585043.0
2008-04-07 16:00:00	SPY	ETF	137.02	137.24	136.7	136.85	6577000.0
2008-04-07 16:30:00	SPY	ETF	136.86	136.8965	136.4	136.58	1867600.0
2008-04-07 17:00:00	SPY	ETF	136.57	136.72	136.54	136.71	76500.0
2008-04-07 17:30:00	SPY	ETF	136.73	136.73	136.58	136.68	21500.0
2008-04-07 18:00:00	SPY	ETF	136.68	136.73	136.67	136.73	25900.0
2008-04-07 18:30:00	SPY	ETF	136.72	136.8	136.68	136.73	58200.0
2008-04-07 19:00:00	SPY	ETF	136.73	136.75	136.66	136.71	14100.0
2008-04-07 19:30:00	SPY	ETF	136.7	136.7	136.6	136.64	17900.0
2008-04-07 04:00:00	QQQ	ETF	46.19	46.25	46.19	46.25	1200.0
2008-04-07 05:00:00	QQQ	ETF	46.2	46.2	46.2	46.2	1000.0
2008-04-07 05:30:00	QQQ	ETF	46.2	46.2	46.2	46.2	500.0
2008-04-07 06:30:00	QQQ	ETF	46.2	46.2	46.16	46.17	13700.0
2008-04-07 07:00:00	QQQ	ETF	46.18	46.21	46.15	46.16	36787.0
2008-04-07 07:30:00	QQQ	ETF	46.17	46.21	46.15	46.18	51053.0
2008-04-07 08:00:00	QQQ	ETF	46.19	46.21	46.16	46.2	319573.0
2008-04-07 08:30:00	QQQ	ETF	46.2	46.21	46.08	46.1	1539851.0
2008-04-07 09:00:00	QQQ	ETF	46.1	46.16	46.06	46.15	525236.0
2008-04-07 09:30:00	QQQ	ETF	46.15	46.24	46.01	46.24	11381622.0
2008-04-07 10:00:00	QQQ	ETF	46.24	46.27	46.02	46.03	8527899.0
2008-04-07 10:30:00	QQQ	ETF	46.03	46.16	45.95	46.13	6617013.0
2008-04-07 11:00:00	QQQ	ETF	46.13	46.2	46.04	46.17	3267502.0
2008-04-07 11:30:00	QQQ	ETF	46.17	46.36	46.17	46.28	6848175.0
2008-04-07 12:00:00	QQQ	ETF	46.28	46.32	46.23	46.3	4614438.0
2008-04-07 12:30:00	QQQ	ETF	46.3	46.41	46.22	46.26	5845585.0
2008-04-07 13:00:00	QQQ	ETF	46.26	46.29	46.14	46.18	4135505.0
2008-04-07 13:30:00	QQQ	ETF	46.18	46.21	46.02	46.0625	4537706.0
2008-04-07 14:00:00	QQQ	ETF	46.07	46.1	45.9	45.9	7172038.0

> showing 50 of 5,857 rows — these rows as CSV

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