PREVIEW / etf_30min / 2009-10-07

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-07.parquet
  size:    228 KB
  rows:    7,521

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
2009-10-07 04:00:00	SPY	ETF	105.49	105.49	105.49	105.49	4500.0
2009-10-07 04:30:00	SPY	ETF	105.49	105.69	105.49	105.69	900.0
2009-10-07 05:00:00	SPY	ETF	105.8	105.8	105.8	105.8	2500.0
2009-10-07 05:30:00	SPY	ETF	105.8	105.8	105.68	105.68	3000.0
2009-10-07 06:00:00	SPY	ETF	105.75	105.75	105.75	105.75	1000.0
2009-10-07 06:30:00	SPY	ETF	105.71	105.71	105.45	105.46	3300.0
2009-10-07 07:00:00	SPY	ETF	105.42	105.57	105.33	105.35	51650.0
2009-10-07 07:30:00	SPY	ETF	105.42	105.54	105.4	105.44	30301.0
2009-10-07 08:00:00	SPY	ETF	105.41	105.49	105.29	105.41	740349.0
2009-10-07 08:30:00	SPY	ETF	105.42	105.42	104.99	105.06	2576826.0
2009-10-07 09:00:00	SPY	ETF	105.06	105.29	105.04	105.28	885236.0
2009-10-07 09:30:00	SPY	ETF	105.27	105.66	105.07	105.44	24839881.0
2009-10-07 10:00:00	SPY	ETF	105.44	105.78	105.3	105.62	16641644.0
2009-10-07 10:30:00	SPY	ETF	105.62	105.64	105.28	105.59	15778309.0
2009-10-07 11:00:00	SPY	ETF	105.6	105.91	105.54	105.58	10980977.0
2009-10-07 11:30:00	SPY	ETF	105.57	105.58	105.24	105.24	8752330.0
2009-10-07 12:00:00	SPY	ETF	105.25	105.5	105.23	105.46	6005442.0
2009-10-07 12:30:00	SPY	ETF	105.45	105.58	105.28	105.57	6071954.0
2009-10-07 13:00:00	SPY	ETF	105.57	105.61	105.38	105.51	4335960.0
2009-10-07 13:30:00	SPY	ETF	105.52	105.62	105.34	105.5	5107074.0
2009-10-07 14:00:00	SPY	ETF	105.4901	105.5	105.21	105.3399	7408552.0
2009-10-07 14:30:00	SPY	ETF	105.33	105.6017	105.27	105.5491	7960678.0
2009-10-07 15:00:00	SPY	ETF	105.54	105.64	105.39	105.61	12415587.0
2009-10-07 15:30:00	SPY	ETF	105.6	105.87	105.33	105.8	18234117.0
2009-10-07 16:00:00	SPY	ETF	105.8	105.95	105.29	105.86	8656123.0
2009-10-07 16:30:00	SPY	ETF	105.86	106.25	105.8	106.17	665813.0
2009-10-07 17:00:00	SPY	ETF	106.17	106.17	106.06	106.15	169128.0
2009-10-07 17:30:00	SPY	ETF	106.17	106.23	106.11	106.17	44357.0
2009-10-07 18:00:00	SPY	ETF	106.17	106.24	106.16	106.16	98541.0
2009-10-07 18:30:00	SPY	ETF	106.17	106.17	106.13	106.15	31916.0
2009-10-07 19:00:00	SPY	ETF	106.15	106.39	106.12	106.34	82226.0
2009-10-07 19:30:00	SPY	ETF	106.34	106.42	106.34	106.36	59075.0
2009-10-07 06:00:00	QQQ	ETF	42.06	42.06	42.05	42.05	500.0
2009-10-07 06:30:00	QQQ	ETF	42.0	42.02	41.96	42.02	44000.0
2009-10-07 07:00:00	QQQ	ETF	41.92	41.97	41.91	41.93	28383.0
2009-10-07 07:30:00	QQQ	ETF	41.95	41.99	41.94	41.97	22230.0
2009-10-07 08:00:00	QQQ	ETF	41.95	41.95	41.87	41.91	263099.0
2009-10-07 08:30:00	QQQ	ETF	41.92	41.92	41.77	41.78	506291.0
2009-10-07 09:00:00	QQQ	ETF	41.8	41.9	41.79	41.89	229293.0
2009-10-07 09:30:00	QQQ	ETF	41.89	42.02	41.77	41.89	14162032.0
2009-10-07 10:00:00	QQQ	ETF	41.9	42.08	41.82	42.0	11840826.0
2009-10-07 10:30:00	QQQ	ETF	42.0	42.0199	41.84	41.98	13780669.0
2009-10-07 11:00:00	QQQ	ETF	41.97	42.07	41.93	41.94	3441717.0
2009-10-07 11:30:00	QQQ	ETF	41.94	41.95	41.85	41.85	4094330.0
2009-10-07 12:00:00	QQQ	ETF	41.85	41.97	41.84	41.93	2838999.0
2009-10-07 12:30:00	QQQ	ETF	41.94	42.01	41.86	41.98	3373927.0
2009-10-07 13:00:00	QQQ	ETF	41.989	41.999	41.9	41.96	1717124.0
2009-10-07 13:30:00	QQQ	ETF	41.96	41.98	41.88	41.92	2394234.0
2009-10-07 14:00:00	QQQ	ETF	41.93	41.93	41.8	41.88	3446301.0
2009-10-07 14:30:00	QQQ	ETF	41.87	41.98	41.86	41.9599	3444556.0

> showing 50 of 7,521 rows — these rows as CSV

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