PREVIEW / etf_30min / 2009-10-26

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-26.parquet
  size:    242 KB
  rows:    7,884

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-26 04:00:00	SPY	ETF	108.43	108.5	108.43	108.5	470.0
2009-10-26 04:30:00	SPY	ETF	108.54	108.54	108.36	108.36	1822.0
2009-10-26 05:00:00	SPY	ETF	108.31	108.45	108.31	108.45	1450.0
2009-10-26 05:30:00	SPY	ETF	108.43	108.61	108.42	108.61	3475.0
2009-10-26 06:00:00	SPY	ETF	108.69	108.7	108.59	108.63	6945.0
2009-10-26 06:30:00	SPY	ETF	108.6	108.66	108.5	108.5	10750.0
2009-10-26 07:00:00	SPY	ETF	108.42	108.44	108.22	108.25	172981.0
2009-10-26 07:30:00	SPY	ETF	108.27	108.32	108.18	108.2	126466.0
2009-10-26 08:00:00	SPY	ETF	108.23	108.69	108.22	108.34	260028.0
2009-10-26 08:30:00	SPY	ETF	108.34	108.38	108.2	108.37	816085.0
2009-10-26 09:00:00	SPY	ETF	108.36	108.51	108.1	108.19	1356675.0
2009-10-26 09:30:00	SPY	ETF	108.2	109.16	108.19	109.062	22561474.0
2009-10-26 10:00:00	SPY	ETF	109.04	109.31	109.04	109.13	14709035.0
2009-10-26 10:30:00	SPY	ETF	109.12	109.23	108.89	109.02	11392437.0
2009-10-26 11:00:00	SPY	ETF	109.02	109.2	108.45	108.45	16983190.0
2009-10-26 11:30:00	SPY	ETF	108.46	108.75	106.96	107.0	48255321.0
2009-10-26 12:00:00	SPY	ETF	107.0	107.25	106.69	107.14	22085568.0
2009-10-26 12:30:00	SPY	ETF	107.14	107.38	106.99	107.3199	13159364.0
2009-10-26 13:00:00	SPY	ETF	107.31	107.37	106.86	107.07	9267325.0
2009-10-26 13:30:00	SPY	ETF	107.07	107.371	107.0	107.12	7992198.0
2009-10-26 14:00:00	SPY	ETF	107.12	107.22	106.8	107.0	8492905.0
2009-10-26 14:30:00	SPY	ETF	106.99	108.0812	106.64	106.9	16995838.0
2009-10-26 15:00:00	SPY	ETF	106.9	107.03	106.61	106.68	10587586.0
2009-10-26 15:30:00	SPY	ETF	106.6701	107.22	106.64	106.84	23460297.0
2009-10-26 16:00:00	SPY	ETF	106.85	109.0937	106.8163	107.03	7950725.0
2009-10-26 16:30:00	SPY	ETF	107.05	107.6174	106.99	107.03	486250.0
2009-10-26 17:00:00	SPY	ETF	107.03	107.07	106.99	107.01	104623.0
2009-10-26 17:30:00	SPY	ETF	106.99	106.99	106.78	106.81	87437.0
2009-10-26 18:00:00	SPY	ETF	106.85	106.97	106.82	106.91	269511.0
2009-10-26 18:30:00	SPY	ETF	106.9	106.94	106.9	106.9	26473.0
2009-10-26 19:00:00	SPY	ETF	106.9	106.91	106.86	106.86	38407.0
2009-10-26 19:30:00	SPY	ETF	106.86	106.95	106.86	106.95	31328.0
2009-10-26 04:30:00	QQQ	ETF	43.25	43.25	43.25	43.25	100.0
2009-10-26 05:30:00	QQQ	ETF	43.31	43.31	43.31	43.31	5000.0
2009-10-26 06:00:00	QQQ	ETF	43.36	43.38	43.36	43.38	600.0
2009-10-26 06:30:00	QQQ	ETF	43.33	43.33	43.31	43.33	5900.0
2009-10-26 07:00:00	QQQ	ETF	43.28	43.28	43.2	43.2	5600.0
2009-10-26 07:30:00	QQQ	ETF	43.18	43.22	43.18	43.2	4740.0
2009-10-26 08:00:00	QQQ	ETF	43.17	43.23	43.17	43.22	50939.0
2009-10-26 08:30:00	QQQ	ETF	43.2	43.24	43.16	43.22	182359.0
2009-10-26 09:00:00	QQQ	ETF	43.22	43.28	43.13	43.16	445521.0
2009-10-26 09:30:00	QQQ	ETF	43.17	43.7	43.16	43.65	13371464.0
2009-10-26 10:00:00	QQQ	ETF	43.66	43.76	43.64	43.64	6940764.0
2009-10-26 10:30:00	QQQ	ETF	43.64	43.71	43.6	43.68	4020835.0
2009-10-26 11:00:00	QQQ	ETF	43.695	43.74	43.51	43.52	7465974.0
2009-10-26 11:30:00	QQQ	ETF	43.51	43.52	42.95	42.95	20212434.0
2009-10-26 12:00:00	QQQ	ETF	42.96	43.2	42.79	43.035	9946024.0
2009-10-26 12:30:00	QQQ	ETF	43.03	43.1	42.91	43.03	6373246.0
2009-10-26 13:00:00	QQQ	ETF	43.04	43.05	42.86	42.9401	4333864.0
2009-10-26 13:30:00	QQQ	ETF	42.94	43.08	42.9	43.005	2649945.0

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

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