PREVIEW / etf_30min / 2010-02-08

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-08.parquet
  size:    248 KB
  rows:    8,162

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
2010-02-08 04:00:00	SPY	ETF	106.99	107.05	106.84	106.91	10414.0
2010-02-08 04:30:00	SPY	ETF	106.97	107.02	106.72	106.81	3900.0
2010-02-08 05:00:00	SPY	ETF	106.84	106.84	106.65	106.8	26200.0
2010-02-08 05:30:00	SPY	ETF	106.8	106.8	106.43	106.47	19200.0
2010-02-08 06:00:00	SPY	ETF	106.39	106.58	106.32	106.58	21000.0
2010-02-08 06:30:00	SPY	ETF	106.45	106.49	106.34	106.37	47900.0
2010-02-08 07:00:00	SPY	ETF	106.37	106.44	106.2	106.22	244439.0
2010-02-08 07:30:00	SPY	ETF	106.2	106.78	106.1	106.67	1445946.0
2010-02-08 08:00:00	SPY	ETF	106.67	106.8	106.12	106.64	757421.0
2010-02-08 08:30:00	SPY	ETF	106.63	106.77	106.49	106.74	726163.0
2010-02-08 09:00:00	SPY	ETF	106.73	106.9	106.67	106.76	2482797.0
2010-02-08 09:30:00	SPY	ETF	106.74	106.74	106.08	106.47	30700071.0
2010-02-08 10:00:00	SPY	ETF	106.47	106.91	106.3682	106.7	20636624.0
2010-02-08 10:30:00	SPY	ETF	106.71	107.02	106.53	107.0	19232604.0
2010-02-08 11:00:00	SPY	ETF	106.99	107.33	106.8	107.06	14758596.0
2010-02-08 11:30:00	SPY	ETF	107.06	107.29	106.98	107.06	9341005.0
2010-02-08 12:00:00	SPY	ETF	107.06	107.15	106.86	107.15	7660702.0
2010-02-08 12:30:00	SPY	ETF	107.1401	107.18	106.99	107.02	6210616.0
2010-02-08 13:00:00	SPY	ETF	107.02	107.05	106.5	106.67	11780820.0
2010-02-08 13:30:00	SPY	ETF	106.68	106.72	106.45	106.56	8219180.0
2010-02-08 14:00:00	SPY	ETF	106.57	106.85	106.57	106.7	8955416.0
2010-02-08 14:30:00	SPY	ETF	106.7	106.75	106.43	106.52	10768391.0
2010-02-08 15:00:00	SPY	ETF	106.5175	106.8	106.11	106.3299	15243635.0
2010-02-08 15:30:00	SPY	ETF	106.33	106.4599	105.8099	105.89	27351648.0
2010-02-08 16:00:00	SPY	ETF	105.88	107.1499	105.85	106.05	11153664.0
2010-02-08 16:30:00	SPY	ETF	106.04	106.07	105.94	105.95	8684480.0
2010-02-08 17:00:00	SPY	ETF	105.98	106.8056	105.88	105.9	3079059.0
2010-02-08 17:30:00	SPY	ETF	105.89	105.95	105.87	105.93	41210.0
2010-02-08 18:00:00	SPY	ETF	105.93	106.1	105.92	106.04	82723.0
2010-02-08 18:30:00	SPY	ETF	105.99	106.07	105.92	106.02	16540.0
2010-02-08 19:00:00	SPY	ETF	106.0	106.17	105.98	106.15	56750.0
2010-02-08 19:30:00	SPY	ETF	106.14	106.18	105.96	106.02	67232.0
2010-02-08 04:00:00	QQQ	ETF	43.14	43.14	43.09	43.09	300.0
2010-02-08 05:00:00	QQQ	ETF	43.01	43.01	43.01	43.01	100.0
2010-02-08 06:00:00	QQQ	ETF	42.92	42.92	42.88	42.88	30600.0
2010-02-08 06:30:00	QQQ	ETF	42.95	42.96	42.9	42.92	10600.0
2010-02-08 07:00:00	QQQ	ETF	42.89	42.93	42.85	42.85	43226.0
2010-02-08 07:30:00	QQQ	ETF	42.85	43.05	42.8	43.02	744216.0
2010-02-08 08:00:00	QQQ	ETF	43.01	43.07	42.81	42.99	1431647.0
2010-02-08 08:30:00	QQQ	ETF	42.98	43.03	42.94	43.03	296830.0
2010-02-08 09:00:00	QQQ	ETF	43.03	43.05	42.92	42.94	505886.0
2010-02-08 09:30:00	QQQ	ETF	42.93	42.94	42.64	42.86	19178617.0
2010-02-08 10:00:00	QQQ	ETF	42.87	43.04	42.82	42.96	9692599.0
2010-02-08 10:30:00	QQQ	ETF	42.96	43.03	42.8899	43.02	5293204.0
2010-02-08 11:00:00	QQQ	ETF	43.02	43.15	43.01	43.06	4885831.0
2010-02-08 11:30:00	QQQ	ETF	43.06	43.18	43.03	43.1	3456433.0
2010-02-08 12:00:00	QQQ	ETF	43.11	43.16	43.03	43.16	2821330.0
2010-02-08 12:30:00	QQQ	ETF	43.16	43.17	43.0612	43.13	3212546.0
2010-02-08 13:00:00	QQQ	ETF	43.13	43.14	42.93	42.98	4854511.0
2010-02-08 13:30:00	QQQ	ETF	42.99	43.01	42.86	42.97	3844633.0

> showing 50 of 8,162 rows — these rows as CSV

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